Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_SCHEDULER_JOB_ARGS

`ALL_SCHEDULER_JOB_ARGS` displays information about the arguments of the Scheduler jobs accessible to the current user.

Related Views

- `DBA_SCHEDULER_JOB_ARGS` displays information about the arguments of all Scheduler jobs in the database.

- `USER_SCHEDULER_JOB_ARGS` displays information about the arguments of the Scheduler jobs owned by the current user. This view does not display the `OWNER` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the job to which the argument belongs
`JOB_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the job to which the argument belongs
`ARGUMENT_NAME` | `VARCHAR2(30)` |  | Optional name of the argument
`ARGUMENT_POSITION` | `NUMBER` |  | Position of the argument in the argument list
`ARGUMENT_TYPE` | `VARCHAR2(61)` |  | Datatype of the argument
`VALUE` | `VARCHAR2(4000)` |  | Value of the argument (in string format) if the argument is a string
`ANYDATA_VALUE` | `ANYDATA` |  | Value of the argument (in AnyData format)
`OUT_ARGUMENT` | `VARCHAR2(5)` |  | Reserved for future use

See Also: "DBA_SCHEDULER_JOB_ARGS" "USER_SCHEDULER_JOB_ARGS"